#include "Admin.h"

class Lecturers:public Users
{
	public:
		Lecturers(Database);
		void lectMenu();
		void addStudentToModule();
		void addStudentToClass();
		void removeStudentFromClass();
		void updateAbsentee();
		void updateNotice();
		void addClass();
		void deleteClass();
		void summaryReport(string, string);
		void changePassword();
		bool checkPassword (string, string);
		
		void displayUserLessons();	//show all lessons user has
		void displayFullNameFromStudentModule(string);	//show all the names of student studying the module
		void displayAllStudentFromDB();		//show all the students in database
		void displayFullNameFromStudentLesson(string);	//show all the names of student studying in the class
		void sendEmail(int, string, string );
		
		bool checkLECTURERSMODULEModuleCode(string); 	//check if the lecturer is teaching the module
		bool checkStudentInAbsentee(string);	//check if student already in absentee record
		bool checkStudentInModule(string, string);	//check if the student is studying the module
		bool checkIsVenueAvailable(string, string);	//check if venue and time slot booked
		bool checkForLessonsId(string);		//check if lesson exist
		bool checkStudentInClass(string, string);	//check if the student exist in the class
		
		string getModuleCodeFromLESSONS(string);	//get the module code from LESSONS using the lessons_id
		string getLessonID();	//get lesson id from user
		string getSlIdFromSTUDENTLESSONS(string, string); 	//get the sl_id from the STUDENTS_LESSONS
		string getPtIdFromPLACETIME(string, string);	//get the ptid of the venue and time slot 
		double totalHours(string,string,string );
};